package com.peace.hospital.opdept.mapper.common;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.peace.hospital.entity.common.Druginformation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 药品信息表 Mapper 接口
 * </p>
 *
 * @author 谢晓峰
 * @since 2019-11-11
 */
@Mapper
public interface DruginformationMapper extends BaseMapper<Druginformation> {

    @Select("select drugprice from hospital_public.druginformation where drugid=#{drugid}")
    Double selectPriceById(Integer drugid);

    @Select("select * from hospital_public.druginformation where drugid=#{drugid}")
    Druginformation selectDrugchargesById(Integer drugid);
}
